#!/usr/bin/python
from flask import Flask
from flask_sqlalchemy import SQLAlchemy

app = Flask(__name__)
app.config['SQLALCHEMY_DATABASE_URI']=\
"mysql+pymysql://dk:123123@192.168.0.201/ssh"
app.config['SQLALCHEMY_TRACK_MODIFICATIONS'] = True
db = SQLAlchemy(app)

class Users(db.Model):
    __tablename__ = 'user'

    user_id = db.Column(db.Integer,primary_key=True)
    user_name =db.Column(db.String)
    passwd = db.Column(db.String)
    department = db.Column(db.String)
    manager = db.Column(db.String)

    def __init__(self,user_id,user_name,passwd,department,manager):
        self.user_id =user_id
        self.user_name = user_name
        self.passwd = passwd
        self.department =department
        self.manager = manager



